SongAlbumRecording
What Is This Thing Called Love? Best of the Nat King Cole Trio, The 1002
   "Sweet and Dry 1494
   "Great American Songwriters-Porter 1741
   "Keely Smith 2421
   "Cole Porter Songbook - Anything Goes 2938
   "Velvet Fog, The 3066
   "Billie Holiday on the Net 3807
   "Swing Era, Music of 1937-1938 5152
   "Ella Sings the Cole Porter Songbook 6994
   "Just for You 10009
   "Mellow Guitar 10085
   "Artie Shaw 10253
   "Night and Day - The Genius of Charlie Parker 11324
   "Leo Reisman and His Orchestra, vol 1 12016

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "What Is This Thing Called Love?"